package com.web.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.web.common.pojos.Car;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper
@Component
public interface CarMapper extends BaseMapper<Car> {
    List<Integer> selectDate();

    List<Integer> selectCountByDate();

    List<String> getCarName(int start, int end);

    int getCarCounts(int start, int end, String carName);

    List<String> getBrandName(int start, int end);

    int getBrandCounts(int start, int end, String brandName);

    List<String> getTop10brand();


    List<String> getBrandNameByBrand(int start, int end, String brandName);

    int getBrandCountsByProvince(int start, int end, String provinceName, String brandName);

    List<String> getCarNameByBrand(int start, int end, String brandName, String province);

    int getCarCountsByProvince(int start, int end, String carName, String province);

}

